Prerequisites

COMMUNICATION

Source	Destination	Ports	Type	Remarks
Orchestrator	DB Server	1521/Custom port	Unidirectional	Orchestrator to database connection
Orchestrator	Application Server	6443	Multi-directional	Orchestrator to Application connection
Orchestrator	Executor	6443,8443	Multi-directional	Orchestrator and Executor two-way communication

DATABASE REQUIREMENTS

UAT Schema Name	Detail	Preferred Schema name for production
RUNCONTROL	Schema for Runcontrol Service	RUNCONTROL
Product (Eg: BALM, BASEL, FTP)	For each product required by client, schema will be needed.	Product (Eg: BALM, BASEL, FTP)

SHARE FOLDER REQUIREMENTS

Drive Name	Subfolder	Content
SH_INPUT	IND/ddmmyyyy	Stores clients input files.
SH_PREPROCESS	IND/ddmmyyyy	Stores preprocessed inputs.
SH_CFDATA	IND/ddmmyyyy	Stores cashflow files.
SH_SUMMARYDATA	IND/ddmmyyyy	Stores final output files.
SH_LOGS	IND/ddmmyyyy	Stores log files.
SH_RESOURCES	IND/(inside IND 3 subfolders CONFIGS, RULES, MASTER)	Configs stores the config files, Rules stores rule files and Master stores other reference files like exchange rate file etc.
SH_PROGRAMS	-	Stores the binaries of the program.

Note: These NFS drive mounting is possible with a NAS storage solution. 10 Gbps connectivity expected between servers and NAS Physical location. Above shared folders must be mounted from the same NFS File Systems like NAS-NFS, Amazon EFS or Azure NFS V3+ File System recommended: NFS V3+, Multiple servers can read & write to disk.

TOOLS

GENERIC TOOLS

Tool	Annexure
curl	Command line tool for API interactions
telnet	Network protocol tool for server communication

MSSQL TOOLS

Tool	Annexure
sqlcmd	Command line utility for executing SQL queries

ORACLE TOOLS

Tool	Annexure
sqlplus	Command line tool for Oracle database queries
sqlldr	Utility for bulk data loading in Oracle